﻿CREATE TABLE [dbo].[ClientPhone] (
    [LoanID]             NVARCHAR (50)  NULL,
    [ClientType]         NVARCHAR (20)  NULL,
    [RelationToBorrower] NVARCHAR (20)  NULL,
    [Name]               NVARCHAR (101) NULL,
    [PhoneType]          NVARCHAR (100) NULL,
    [Phone/Fax]          NVARCHAR (50)  NULL,
    [CountryCode]        NVARCHAR (10)  NULL,
    [PhoneNumber]        NVARCHAR (20)  NULL,
    [Extension]          NVARCHAR (10)  NULL,
    [EffectiveDate]      DATETIME       NULL,
    [ExpirationDate]     DATETIME       NULL
);

